Exporting K-1 Data to a Spreadsheet
You can export K-1 data to a spreadsheet from the return types and entities shown in the following table. Please note that the data that is exported varies for the different return types.
Return Type | Entities for Whom Data is Exported | Data that can be Exported |
---|---|---|
Partnership | Partners | K-1 data, ratios, amount allocations, Schedule K overrides, K-1 footnotes |
S Corporation | Shareholders | |
Fiduciary | Beneficiaries | K-1 data, K-1 footnotes |
To export K-1 data to a spreadsheet, do the following:
- Open the Partnership, S Corporation, or Fiduciary return for which you want to export K-1 data.
- Select K-1 Data > K-1 to Spreadsheet in the Export group on the Import / Export tab.
-
If needed, click Browse to navigate to and select a different location where the export file should be saved.
- Select the data types to export. The default selections and options vary based on the type of return from which you are exporting data.
- K-1 data. Exports Schedule K-1 data without rounding for Partnership and S Corporation.
- Ratio. Exports Schedule K-1 data without rounding for Partnership and S Corporation.
- Amount allocations. Exports Schedule K-1 data without rounding for Partnership and S Corporation.
- Schedule K overrides. Exports Schedule K Totals Overrides without rounding consisting for Partnership S Corporation.
- K-1 footnotes. Exports Schedule K-1 footnotes for Partnership, S Corporation, and Fiduciary.
- Click Export.
- Review the log summary when the export is completed. The log summary indicates whether the export was successful or not.
- If needed, when the export is completed, you can do one of the following with the log summary:
- Click Copy to copy the log summary to the Clipboard.
- Click Print to print the summary.
- Click Details to view more information about the export.
- Click Finish.